
Use NEXUS_DB

GO
--------------------------------------Insert---------------
CREATE PROC insertCity
	@CityName nvarchar(255)
AS
INSERT INTO  City(CityName) VALUES(@CityName)

GO
---------------------------------------------------update-------------------
---------------------------------------Delete--------------------

CREATE PROC deleteCity
	@CityID int
AS
	DELETE FROM City WHERE CityID=@CityID
GO
CREATE PROC getAllCity
AS
SELECT * from City
GO



